//package com.ugoodtech.mdcc.core.repository;
//
//import com.ugoodtech.mdcc.core.domain.StationServiceReport;
//import org.springframework.data.jpa.repository.Query;
//import org.springframework.data.querydsl.QueryDslPredicateExecutor;
//import org.springframework.data.repository.PagingAndSortingRepository;
//
//import java.util.List;
//
//public interface StationServiceReportRepository extends PagingAndSortingRepository<StationServiceReport, Long>
//        , QueryDslPredicateExecutor<StationServiceReport> {
//
//    @Query(value = "select a.name,count(b.id) from question_answer_options a left join station_service_report b on b.serviceObjectives=a.name  where a.question_id=155 group by a.name", nativeQuery = true)
//    List<Object[]> statByServiceObjectives();
//
//
//    @Query(value = " select a.name,count(b.id) from question_answer_options a left join station_service_report b on b.serviceResults=a.name  where a.question_id=156 group by a.name", nativeQuery = true)
//    List<Object[]> statByServiceResult();
//
//}
